{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Request Form","Workorder","Pricelist","Apartments","Extra","Help"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Request Form","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Welcome to Your Apartment's Maintenance Request Site"]
[]
["To begin please select your apartment number from the list below:"]
[]
[null,"Apartment #"]
[]
[]
[]
[null,"Bathroom"]
[]
[]
[null,"Bedroom"]
[]
[]
[null,"Kitchen"]
[]
[]
[null,"Living Room"]
[]
[]
[]
[]
[null,"Other"]

{"sheet":"Workorder","index":1,"n_rows":32,"n_cols":30,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Work Order"]
[]
["Apartment #:",200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,"Repair","New","Cost / Type"]
["Bathroom"]
["   Drain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($B5:$AA5, \"R\")","v":0},{"$f":"COUNTIF($B5:$AA5, \"N\")","v":0},{"$f":"AB5*Pricelist!B5+Workorder!AC5*Pricelist!C5","v":0}]
["   Pipes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($B6:$AA6, \"R\")","v":0},{"$f":"COUNTIF(B6:AA6, \"N\")","v":0},{"$f":"AB6*Pricelist!B6+Workorder!AC6*Pricelist!C6","v":0}]
["   Sink",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB7*Pricelist!B7+Workorder!AC7*Pricelist!C7","v":0}]
["   Toilet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB8*Pricelist!B8+Workorder!AC8*Pricelist!C8","v":0}]
["Bedroom"]
["   Bed Frame",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB10*Pricelist!B10+Workorder!AC10*Pricelist!C10","v":0}]
["   Desk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB11*Pricelist!B11+Workorder!AC11*Pricelist!C11","v":0}]
["   Dresser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB12*Pricelist!B12+Workorder!AC12*Pricelist!C12","v":0}]
["Kitchen"]
["   Baker's Rack",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB14*Pricelist!B14+Workorder!AC14*Pricelist!C14","v":0}]
["   Microwave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB15*Pricelist!B15+Workorder!AC15*Pricelist!C15","v":0}]
["   Refrigerator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB16*Pricelist!B16+Workorder!AC16*Pricelist!C16","v":0}]
["   Kitchen Sink",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB17*Pricelist!B17+Workorder!AC17*Pricelist!C17","v":0}]
["   Stove",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB18*Pricelist!B18+Workorder!AC18*Pricelist!C18","v":0}]
["   Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB19*Pricelist!B19+Workorder!AC19*Pricelist!C19","v":0}]
["Living Room"]
["   Bookcase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB21*Pricelist!B21+Workorder!AC21*Pricelist!C21","v":0}]
["   Coffee Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB22*Pricelist!B22+Workorder!AC22*Pricelist!C22","v":0}]
["   Couch",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB23*Pricelist!B23+Workorder!AC23*Pricelist!C23","v":0}]
["   Side Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB24*Pricelist!B24+Workorder!AC24*Pricelist!C24","v":0}]
["Other"]
["   Air Conditioner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB26*Pricelist!B26+Workorder!AC26*Pricelist!C26","v":0}]
["   Furnace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB27*Pricelist!B27+Workorder!AC27*Pricelist!C27","v":0}]
["   Vacuum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB28*Pricelist!B28+Workorder!AC28*Pricelist!C28","v":0}]
["   Water Heater",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AB29*Pricelist!B29+Workorder!AC29*Pricelist!C29","v":0}]
["Cost / Apt",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AB5:AB29*Pricelist!B5:B29)","v":0},{"$f":"SUM(AC5:AC29*Pricelist!C5:C29)","v":0},{"$f":"SUM(AD5:AD29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total : ",{"$f":"SUM(B30:AA30)","v":0}]

{"sheet":"Pricelist","index":2,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Price List"]
[]
[null,"Repair","New"]
["Bathroom"]
["   Drain",80,110]
["   Pipes",20,30]
["   Sink",80,100]
["   Toilet",100,150]
["Bedroom"]
["   Bed Frame",120,300]
["   Desk",60,170]
["   Dresser",60,180]
["Kitchen"]
["   Baker's Rack",10,60]
["   Microwave",80,125]
["   Refrigerator",200,525]
["   Kitchen Sink",50,125]
["   Stove",200,380]
["   Table",50,140]
["Living Room"]
["   Bookcase",40,60]
["   Coffee Table",50,150]
["   Couch",150,400]
["   Side Table",30,90]
["Other"]
["   Air Conditioner",800,1000]
["   Furnace",600,800]
["   Vacuum",90,160]
["   Water Heater",250,350]

{"sheet":"Apartments","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
["Apartment List"]
[]
[null,"Unit #","Occupants"]
[null,200,3,null,"Repair"]
[null,{"$f":"B5+1","v":201},3,null,"Need New"]
[null,{"$f":"B6+1","v":202},3]
[null,203,3]
[null,204,2]
[null,205,3]
[null,206,2]
[null,207,3]
[null,208,2]
[null,209,3]
[null,210,2]
[null,211,1]
[null,212,2]
[null,213,3]
[null,214,2]
[null,215,1]
[null,216,3]
[null,217,3]
[null,218,4]
[null,{"$f":"B23+1","v":219},3]
[null,{"$f":"B24+1","v":220},3]
[null,{"$f":"B25+1","v":221},2]
[null,{"$f":"B26+1","v":222},3]
[null,223,2]
[null,224,3]
[null,225,2]

{"sheet":"Extra","index":4,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["EXTRA DATA - NOT FOR EDITING"]
[]
[]
[]
[null,"Bathroom"]
[]
[null,{"$f":"Workorder!A5","v":"   Drain"}]
[null,{"$f":"Workorder!A6","v":"   Pipes"}]
[null,{"$f":"Workorder!A7","v":"   Sink"}]
[null,{"$f":"Workorder!A8","v":"   Toilet"}]
[null,"Bedroom"]
[]
[null,{"$f":"Workorder!A10","v":"   Bed Frame"}]
[null,{"$f":"Workorder!A11","v":"   Desk"}]
[null,{"$f":"Workorder!A12","v":"   Dresser"}]
[null,"Kitchen"]
[]
[null,{"$f":"Workorder!A14","v":"   Baker's Rack"}]
[null,{"$f":"Workorder!A15","v":"   Microwave"}]
[null,{"$f":"Workorder!A16","v":"   Refrigerator"}]
[null,{"$f":"Workorder!A17","v":"   Kitchen Sink"}]
[null,{"$f":"Workorder!A18","v":"   Stove"}]
[null,{"$f":"Workorder!A19","v":"   Table"}]
[null,"Living Room"]
[]
[null,{"$f":"Workorder!A21","v":"   Bookcase"}]
[null,{"$f":"Workorder!A22","v":"   Coffee Table"}]
[null,{"$f":"Workorder!A23","v":"   Couch"}]
[null,{"$f":"Workorder!A24","v":"   Side Table"}]
[null,"Other"]
[]
[null,{"$f":"Workorder!A26","v":"   Air Conditioner"}]
[null,{"$f":"Workorder!A27","v":"   Furnace"}]
[null,{"$f":"Workorder!A28","v":"   Vacuum"}]
[null,{"$f":"Workorder!A29","v":"   Water Heater"}]

{"sheet":"Help","index":5,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Instructions"]
[null,"For tenant:",null,"Use Request Form Sheet"]
[1,"Select Apartment number."]
[2,"Choose a room where repairs are needed."]
[3,"Choose wether or not repairs are sufficient or a new item is necessary."]
[4,"Click Submit Button."]
[]
[]
[null,"For Apartment Management:",null,null,null,null,"Use Work Order Sheet"]
[1,"Work Order Page will automatically sum prices for requested work."]
[2,"Work Order page will sum number of repairs and number of new items seperately."]
[3,"Work Order page will display needs of tenants."]
[]
[]
[]
[]
["Objectives"]
[]
[null,"To help keep track of needed repairs and replacements for an apartment complex and their costs."]
[null,"To simplify the process of material take off and pricing of needed jobs."]
[null,"We wanted to supply an integrated site that is easy to use for both tenant and apartment manager."]
[]
["Note:","Hidden Pages were used for code purposes."]